# -*- coding:utf-8 -*-
import pymssql

# class de ():
# def sql_server(abc="select * from Plasma.BloodTestConsumables as brc"):

# 数据库服务器信息
server = "192.168.1.91"
user = "sa"
password = r"admin123!@#+1s"
database = "VISMS_11"
conn = pymssql.connect(host='192.168.31.221', user='sa', password='123456', database='btmsFszyy20220420',
                       charset='utf8')
cur = conn.cursor()
sql = 'select top 1 * from UserDetail'
cur.execute(sql)
rows = cur.fetchall()
conn.close()
print(rows)
# return rows